--This Test Should have 2 children for both pass and fail task
INSERT INTO AUTOSC.CFG_REQUEST_TYPE (REQUEST_TYPE_ID, REQUEST_TYPE_NAME, IS_REQUESTABLE) VALUES(CFG_REQUEST_TYPE_SEQ.nextVal, 'JUNIT_TEST_REQUEST_TYPE_05', 'Y');

INSERT INTO AUTOSC.CFG_TASK_TYPE ( TASK_TYPE_ID, TASK_TYPE_NAME, TASK_CATEGORY_ID, MAX_RETRY_COUNT, CODE_GROUP, EXT_AUTOSC, PRIORITY, RUNTIME_LENGTH) VALUES ( CFG_TASK_TYPE_SEQ.nextVal, 'JUNIT_TEST_TASK_TYPE_05_A', (SELECT TASK_CATEGORY_ID FROM AUTOSC.CFG_TASK_CATEGORY_INFO WHERE TASK_CATEGORY='SWEEP'), 2, 'A', 'T', 5, 1440 );

INSERT INTO AUTOSC.CFG_REQUEST_DEFN (REQUEST_DEFN_ID, REQUEST_TYPE_ID, MODALITY, MODEL_TYPE, REQUEST_DESC, INITIAL_TASK_ID, REQUESTER, VERIFIER, EXPIRES_ON) VALUES(CFG_REQUEST_DEFN_SEQ.nextVal, (SELECT REQUEST_TYPE_ID FROM AUTOSC.CFG_REQUEST_TYPE WHERE REQUEST_TYPE_NAME='JUNIT_TEST_REQUEST_TYPE_05'), 'GST', 'GST', 'JUNIT_TEST_TYPE_DEFN_05', (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME='JUNIT_TEST_TASK_TYPE_05_A'), 'navdeep.mahajan@ge.com', 'navdeep.mahajan@ge.com', (SYSDATE+365));

INSERT INTO AUTOSC.CFG_TASK_TYPE ( TASK_TYPE_ID, TASK_TYPE_NAME, TASK_CATEGORY_ID, MAX_RETRY_COUNT, CODE_GROUP, EXT_AUTOSC, PRIORITY, RUNTIME_LENGTH) VALUES ( CFG_TASK_TYPE_SEQ.nextVal, 'JUNIT_TEST_TASK_TYPE_05_B', (SELECT TASK_CATEGORY_ID FROM AUTOSC.CFG_TASK_CATEGORY_INFO WHERE TASK_CATEGORY='SWEEP'), 1, 'D', 'T', 5, 1440 );
INSERT INTO AUTOSC.CFG_TASK_TYPE ( TASK_TYPE_ID, TASK_TYPE_NAME, TASK_CATEGORY_ID, MAX_RETRY_COUNT, CODE_GROUP, EXT_AUTOSC, PRIORITY, RUNTIME_LENGTH) VALUES ( CFG_TASK_TYPE_SEQ.nextVal, 'JUNIT_TEST_TASK_TYPE_05_C', (SELECT TASK_CATEGORY_ID FROM AUTOSC.CFG_TASK_CATEGORY_INFO WHERE TASK_CATEGORY='NOTIFY'), 1, 'D', 'T', 5, 1440 );
INSERT INTO AUTOSC.CFG_TASK_TYPE ( TASK_TYPE_ID, TASK_TYPE_NAME, TASK_CATEGORY_ID, MAX_RETRY_COUNT, CODE_GROUP, EXT_AUTOSC, PRIORITY, RUNTIME_LENGTH) VALUES ( CFG_TASK_TYPE_SEQ.nextVal, 'JUNIT_TEST_TASK_TYPE_05_D', (SELECT TASK_CATEGORY_ID FROM AUTOSC.CFG_TASK_CATEGORY_INFO WHERE TASK_CATEGORY='NOTIFY'), 1, 'D', 'T', 5, 1440 );
INSERT INTO AUTOSC.CFG_TASK_TYPE ( TASK_TYPE_ID, TASK_TYPE_NAME, TASK_CATEGORY_ID, MAX_RETRY_COUNT, CODE_GROUP, EXT_AUTOSC, PRIORITY, RUNTIME_LENGTH) VALUES ( CFG_TASK_TYPE_SEQ.nextVal, 'JUNIT_TEST_TASK_TYPE_05_E', (SELECT TASK_CATEGORY_ID FROM AUTOSC.CFG_TASK_CATEGORY_INFO WHERE TASK_CATEGORY='SWEEP'), 1, 'D', 'T', 5, 1440 );
INSERT INTO AUTOSC.CFG_TASK_TYPE ( TASK_TYPE_ID, TASK_TYPE_NAME, TASK_CATEGORY_ID, MAX_RETRY_COUNT, CODE_GROUP, EXT_AUTOSC, PRIORITY, RUNTIME_LENGTH) VALUES ( CFG_TASK_TYPE_SEQ.nextVal, 'JUNIT_TEST_TASK_TYPE_05_F', (SELECT TASK_CATEGORY_ID FROM AUTOSC.CFG_TASK_CATEGORY_INFO WHERE TASK_CATEGORY='SWEEP'), 1, 'D', 'T', 5, 1440 );
INSERT INTO AUTOSC.CFG_TASK_TYPE ( TASK_TYPE_ID, TASK_TYPE_NAME, TASK_CATEGORY_ID, MAX_RETRY_COUNT, CODE_GROUP, EXT_AUTOSC, PRIORITY, RUNTIME_LENGTH) VALUES ( CFG_TASK_TYPE_SEQ.nextVal, 'JUNIT_TEST_TASK_TYPE_05_G', (SELECT TASK_CATEGORY_ID FROM AUTOSC.CFG_TASK_CATEGORY_INFO WHERE TASK_CATEGORY='SWEEP'), 1, 'D', 'T', 5, 1440 );
INSERT INTO AUTOSC.CFG_TASK_TYPE ( TASK_TYPE_ID, TASK_TYPE_NAME, TASK_CATEGORY_ID, MAX_RETRY_COUNT, CODE_GROUP, EXT_AUTOSC, PRIORITY, RUNTIME_LENGTH) VALUES ( CFG_TASK_TYPE_SEQ.nextVal, 'JUNIT_TEST_TASK_TYPE_05_H', (SELECT TASK_CATEGORY_ID FROM AUTOSC.CFG_TASK_CATEGORY_INFO WHERE TASK_CATEGORY='SWEEP'), 1, 'D', 'T', 5, 1440 );
INSERT INTO AUTOSC.CFG_TASK_TYPE ( TASK_TYPE_ID, TASK_TYPE_NAME, TASK_CATEGORY_ID, MAX_RETRY_COUNT, CODE_GROUP, EXT_AUTOSC, PRIORITY, RUNTIME_LENGTH) VALUES ( CFG_TASK_TYPE_SEQ.nextVal, 'JUNIT_TEST_TASK_TYPE_05_I', (SELECT TASK_CATEGORY_ID FROM AUTOSC.CFG_TASK_CATEGORY_INFO WHERE TASK_CATEGORY='SWEEP'), 1, 'D', 'T', 5, 1440 );
INSERT INTO AUTOSC.CFG_TASK_TYPE ( TASK_TYPE_ID, TASK_TYPE_NAME, TASK_CATEGORY_ID, MAX_RETRY_COUNT, CODE_GROUP, EXT_AUTOSC, PRIORITY, RUNTIME_LENGTH) VALUES ( CFG_TASK_TYPE_SEQ.nextVal, 'JUNIT_TEST_TASK_TYPE_05_J', (SELECT TASK_CATEGORY_ID FROM AUTOSC.CFG_TASK_CATEGORY_INFO WHERE TASK_CATEGORY='NOTIFY'), 1, 'D', 'T', 5, 1440 );

INSERT INTO AUTOSC.CFG_TASK_RELATIONSHIP ( RELATION_ID, PARENT_ID, CHILD_ID) VALUES ( AUTOSC.CFG_TASK_RELATIONSHIP_SEQ.nextVal,(SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME='JUNIT_TEST_TASK_TYPE_05_A') , (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME='JUNIT_TEST_TASK_TYPE_05_B'));
INSERT INTO AUTOSC.CFG_TASK_RELATIONSHIP ( RELATION_ID, PARENT_ID, CHILD_ID) VALUES ( AUTOSC.CFG_TASK_RELATIONSHIP_SEQ.nextVal,(SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME='JUNIT_TEST_TASK_TYPE_05_B') , (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME='JUNIT_TEST_TASK_TYPE_05_C'));
INSERT INTO AUTOSC.CFG_TASK_RELATIONSHIP ( RELATION_ID, PARENT_ID, CHILD_ID) VALUES ( AUTOSC.CFG_TASK_RELATIONSHIP_SEQ.nextVal,(SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME='JUNIT_TEST_TASK_TYPE_05_C') , (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME='JUNIT_TEST_TASK_TYPE_05_D'));
INSERT INTO AUTOSC.CFG_TASK_RELATIONSHIP ( RELATION_ID, PARENT_ID, CHILD_ID) VALUES ( AUTOSC.CFG_TASK_RELATIONSHIP_SEQ.nextVal,(SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME='JUNIT_TEST_TASK_TYPE_05_D') , (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME='JUNIT_TEST_TASK_TYPE_05_E'));
INSERT INTO AUTOSC.CFG_TASK_RELATIONSHIP ( RELATION_ID, PARENT_ID, CHILD_ID) VALUES ( AUTOSC.CFG_TASK_RELATIONSHIP_SEQ.nextVal,(SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME='JUNIT_TEST_TASK_TYPE_05_E') , (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME='JUNIT_TEST_TASK_TYPE_05_F'));
INSERT INTO AUTOSC.CFG_TASK_RELATIONSHIP ( RELATION_ID, PARENT_ID, CHILD_ID) VALUES ( AUTOSC.CFG_TASK_RELATIONSHIP_SEQ.nextVal,(SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME='JUNIT_TEST_TASK_TYPE_05_F') , (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME='JUNIT_TEST_TASK_TYPE_05_G'));
INSERT INTO AUTOSC.CFG_TASK_RELATIONSHIP ( RELATION_ID, PARENT_ID, CHILD_ID) VALUES ( AUTOSC.CFG_TASK_RELATIONSHIP_SEQ.nextVal,(SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME='JUNIT_TEST_TASK_TYPE_05_G') , (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME='JUNIT_TEST_TASK_TYPE_05_H'));
INSERT INTO AUTOSC.CFG_TASK_RELATIONSHIP ( RELATION_ID, PARENT_ID, CHILD_ID) VALUES ( AUTOSC.CFG_TASK_RELATIONSHIP_SEQ.nextVal,(SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME='JUNIT_TEST_TASK_TYPE_05_H') , (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME='JUNIT_TEST_TASK_TYPE_05_I'));
INSERT INTO AUTOSC.CFG_TASK_RELATIONSHIP ( RELATION_ID, PARENT_ID, CHILD_ID) VALUES ( AUTOSC.CFG_TASK_RELATIONSHIP_SEQ.nextVal,(SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME='JUNIT_TEST_TASK_TYPE_05_I') , (SELECT TASK_TYPE_ID FROM AUTOSC.CFG_TASK_TYPE WHERE TASK_TYPE_NAME='JUNIT_TEST_TASK_TYPE_05_J'));

INSERT INTO AUTOSC.CFG_TASK_CLASS_MAP (task_class_map_id, task_type_name, task_class) VALUES (CFG_TASK_CLASS_MAP_ID_SEQ.nextVal, 'JUNIT_TEST_TASK_TYPE_05_A', 'dummyTask');
INSERT INTO AUTOSC.CFG_TASK_CLASS_MAP (task_class_map_id, task_type_name, task_class) VALUES (CFG_TASK_CLASS_MAP_ID_SEQ.nextVal, 'JUNIT_TEST_TASK_TYPE_05_B', 'dummyTask');
INSERT INTO AUTOSC.CFG_TASK_CLASS_MAP (task_class_map_id, task_type_name, task_class) VALUES (CFG_TASK_CLASS_MAP_ID_SEQ.nextVal, 'JUNIT_TEST_TASK_TYPE_05_C', 'notifyTask');
INSERT INTO AUTOSC.CFG_TASK_CLASS_MAP (task_class_map_id, task_type_name, task_class) VALUES (CFG_TASK_CLASS_MAP_ID_SEQ.nextVal, 'JUNIT_TEST_TASK_TYPE_05_D', 'notifyTask');	
INSERT INTO AUTOSC.CFG_TASK_CLASS_MAP (task_class_map_id, task_type_name, task_class) VALUES (CFG_TASK_CLASS_MAP_ID_SEQ.nextVal, 'JUNIT_TEST_TASK_TYPE_05_E', 'dummyTask');
INSERT INTO AUTOSC.CFG_TASK_CLASS_MAP (task_class_map_id, task_type_name, task_class) VALUES (CFG_TASK_CLASS_MAP_ID_SEQ.nextVal, 'JUNIT_TEST_TASK_TYPE_05_F', 'dummyTask');
INSERT INTO AUTOSC.CFG_TASK_CLASS_MAP (task_class_map_id, task_type_name, task_class) VALUES (CFG_TASK_CLASS_MAP_ID_SEQ.nextVal, 'JUNIT_TEST_TASK_TYPE_05_G', 'dummyTask');
INSERT INTO AUTOSC.CFG_TASK_CLASS_MAP (task_class_map_id, task_type_name, task_class) VALUES (CFG_TASK_CLASS_MAP_ID_SEQ.nextVal, 'JUNIT_TEST_TASK_TYPE_05_H', 'dummyTask');	
INSERT INTO AUTOSC.CFG_TASK_CLASS_MAP (task_class_map_id, task_type_name, task_class) VALUES (CFG_TASK_CLASS_MAP_ID_SEQ.nextVal, 'JUNIT_TEST_TASK_TYPE_05_I', 'dummyTask');
INSERT INTO AUTOSC.CFG_TASK_CLASS_MAP (task_class_map_id, task_type_name, task_class) VALUES (CFG_TASK_CLASS_MAP_ID_SEQ.nextVal, 'JUNIT_TEST_TASK_TYPE_05_J', 'notifyTask');	
Commit;